package top.timous.mapper.teacher;

import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;
import top.timous.pojo.ScoreEntity;
import top.timous.pojo.StudentEntity;
import top.timous.pojo.TeacherEntity;
import top.timous.vo.*;

import java.util.List;

/**
 * @Author luming
 * @Date 2020/12/4 16:37
 */
@Repository
@Mapper
public interface TeacherMapper {
    //登录
    TeacherEntity queryTeacherIdAndPwd(TeacherEntity teacherEntity);
    //查询多个学生信息
    List<StudentEntity> queryAllStudentInfo(StudentInfos studentInfos);
    //添加学生信息
    int addStudentInfo(StudentEntity studentEntity);
    //修改学生信息
    void updateStudentInfo(StudentEntity studentEntity);
    //删除学生信息
    void deleteStudentInfo(String id);
    //查询所有的学生信息记录,便于分页
    int queryAllStudentInfoCount(StudentInfos studentInfos);
    //批量删除学生信息
    void deleteStudentInfos(String[] ids);
    //修改自己密码
    int updatePassword(TeacherEntity teacherEntity);
    //查看自己基本信息
    TeacherEntity queryOwnInfo(TeacherEntity teacherEntity);

    //根据学号查找某一位学生成绩
    List<StudentbyPassword> queryStuScoreByStuId(StudentbyPassword studentbyPassword);

    String queryClassNameById(Integer classId);

    String queryHomeNameById(Integer homeId);

    Integer queryclassIdByclassName(String className);

    Integer queryhomeIdByhomeName(String homeName);


    List<TeacherCourse> queryclassInfo(String teaId);

    

    int queryStuIdByCouId(String stuId);

    String queryCouNameByCouId(int couId);

    Integer queryScoreByCouId(int couId);

    Integer queryCreditByCouId(int couId);



    Integer queryCouIdByCouName(String couName);

    List<StudentScore> queryStudentScore(StudentScore studentScore);


    String queryCouNameByTeaId(String teaId);



    StudentEntity queryStuInfoByStuId(String stuId);

    void updateScore(StudentScore student);

    void addScore(ScoreEntity scoreEntity);

    String queryStuNameByStuId(String stuId);

    Integer queryCreditByCouName(String couName);

    int queryStudentScoreCount(StudentScore score);

    int queryAmount(Amount amount);
}
